BEGIN TRANSACTION AddBooking1
	BEGIN TRY
		INSERT INTO [Booking] (BookingNo, BookingDateTime, PickupDateTime, PickupAddress, PickupCityId, PickupPostcode, DestinationAddress, DestinationCityId, DestinationPostcode, JourneyMileage, CarSize, AssignedDriverNo, DeliveredDateTime, FareAmount, Payment)
		VALUES (1, '01/01/18 08:00', '01/01/18 08:15', '52 Walter Road', '1', 'SA1 9FD', '88 Uplands Crescent', '1', 'SA2 0OW', 2, 'small', '1', '01/01/18 08:32', 15.25, 'Cash')
		
		COMMIT TRANSACTION AddBooking1
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddBooking1
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddBooking2
	BEGIN TRY
		INSERT INTO [Booking] (BookingNo, BookingDateTime, PickupDateTime, PickupAddress, PickupCityId, PickupPostcode, DestinationAddress, DestinationCityId, DestinationPostcode, JourneyMileage, CarSize, AssignedDriverNo, DeliveredDateTime, FareAmount, Payment)
		VALUES (2, '01/01/18 09:00', '01/01/18 09:15', '52 Mount Pleasant Road', '1', 'SA1 6EL', '20 High Street', '1', 'SA2 0AW', 3.1, 'small', '2', '01/01/18 09:52', 21.25, 'Cash')
		
		COMMIT TRANSACTION AddBooking2
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddBooking2
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddBooking3
	BEGIN TRY
		INSERT INTO [Booking] (BookingNo, BookingDateTime, PickupDateTime, PickupAddress, PickupCityId, PickupPostcode, DestinationAddress, DestinationCityId, DestinationPostcode, JourneyMileage, CarSize, AssignedDriverNo, DeliveredDateTime, FareAmount, Payment)
		VALUES (3, '01/01/18 12:00', '01/01/18 12:15', '52 Jilian Way', '1', 'SA1 2LD', '10 Uplands Crescent', '1', 'SA2 0OW', 3, 'small', '1', '01/01/18 12:40', 18.25, 'Cash')
		
		COMMIT TRANSACTION AddBooking3
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddBooking3
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;


BEGIN TRANSACTION AddBooking4
	BEGIN TRY
		INSERT INTO [Booking] (BookingNo, BookingDateTime, PickupDateTime, PickupAddress, PickupCityId, PickupPostcode, DestinationAddress, DestinationCityId, DestinationPostcode, JourneyMileage, CarSize, AssignedDriverNo, DeliveredDateTime, FareAmount, Payment)
		VALUES (4, '02/01/18 08:00', '02/01/18 08:15', '52 Fabian Road', '1', 'SA1 1FD', '8 Uplands Crescent', '1', 'SA2 0OW', 2, 'small', '3', '02/01/18 08:32', 15.30, 'Cash')
		
		COMMIT TRANSACTION AddBooking4
	END TRY;
	
	BEGIN CATCH
		ROLLBACK TRANSACTION AddBooking4
		Print 'An error has occurred';
	END CATCH;
END TRANSACTION;